{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.419275800Z",
     "start_time": "2024-08-20T07:06:40.782897700Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "brand_name--> 康比特\n",
      "日期--> 20240819\n"
     ]
    },
    {
     "data": {
      "text/plain": "                                   商品  \\\n1      康比特益生菌增肌粉复合蛋白粉瘦子增肌增重运动健身学生营养加餐   \n2    康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS   \n3     康比特益生菌增肌粉瘦人增肌增重乳清运动锻炼健身蛋白质粉mass   \n4       康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss   \n5      【增肌塑形】康比特分离乳清蛋白粉低脂低碳高蛋白健身增肌蛋白粉   \n..                                ...   \n192     康比特加速能量胶运动跑步盐丸马拉松越野骑行电解质长跑酸轻片   \n193     康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步   \n194  康比特锌镁肌酸便携装6g*10 组合装（口味不可选）运动健身补充   \n195    康比特运动营养加速电解质盐丸 马拉松运动跑步户外碳水袋装便携   \n196  【夏训体验】康比特加速能量胶盐丸润力饮 马拉松长跑 运动补给充能   \n\n                                               蝉妈妈商品链接  \\\n1    https://www.chanmama.com/promotionDetail/ny43D...   \n2    https://www.chanmama.com/promotionDetail/0aUUU...   \n3    https://www.chanmama.com/promotionDetail/CCqFd...   \n4    https://www.chanmama.com/promotionDetail/1zKky...   \n5    https://www.chanmama.com/promotionDetail/988c4...   \n..                                                 ...   \n192  https://www.chanmama.com/promotionDetail/QEOFD...   \n193  https://www.chanmama.com/promotionDetail/Zqvmf...   \n194  https://www.chanmama.com/promotionDetail/lojFm...   \n195  https://www.chanmama.com/promotionDetail/gFy1Q...   \n196  https://www.chanmama.com/promotionDetail/PiYC9...   \n\n                                                抖音商品链接  \\\n1    https://haohuo.jinritemai.com/ecommerce/trade/...   \n2    https://haohuo.jinritemai.com/ecommerce/trade/...   \n3    https://haohuo.jinritemai.com/ecommerce/trade/...   \n4    https://haohuo.jinritemai.com/ecommerce/trade/...   \n5    https://haohuo.jinritemai.com/ecommerce/trade/...   \n..                                                 ...   \n192  https://haohuo.jinritemai.com/ecommerce/trade/...   \n193  https://haohuo.jinritemai.com/ecommerce/trade/...   \n194  https://haohuo.jinritemai.com/ecommerce/trade/...   \n195  https://haohuo.jinritemai.com/ecommerce/trade/...   \n196  https://haohuo.jinritemai.com/ecommerce/trade/...   \n\n                                                  商品图片               商品分类  \\\n1    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n2    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n3    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n4    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n5    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n..                                                 ...                ...   \n192  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n193  https://cdn-images.chanmama.com/douyin/product...      食品饮料-酒水/饮料-饮料   \n194  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n195  https://cdn-images.chanmama.com/douyin/product...      食品饮料-酒水/饮料-饮料   \n196  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n\n               小店      价格    销量        销售额 关联达人 关联视频 关联直播  \n1      康比特运动营养旗舰店  199.00   861  171339.00    2    0    2  \n2        康比特官方旗舰店  366.84   446  163611.45   16    1   17  \n3      康比特运动营养旗舰店   79.11  1832  144932.00   14   13    4  \n4      康比特运动营养旗舰店  293.45   358  105056.00    3    0    5  \n5        康比特官方旗舰店  350.52   254   89032.00    3    0    4  \n..            ...     ...   ...        ...  ...  ...  ...  \n192       利东食品专营店   18.00     1      18.00    0    0    0  \n193  康比特运动营养水饮旗舰店    9.90     1       9.90    0    0    0  \n194      康比特官方旗舰店    9.90     1       9.90    0    0    0  \n195  康比特运动营养水饮旗舰店    4.80     2       9.60    0    0    0  \n196       利东食品专营店    9.00     1       9.00    0    0    0  \n\n[196 rows x 12 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>商品</th>\n      <th>蝉妈妈商品链接</th>\n      <th>抖音商品链接</th>\n      <th>商品图片</th>\n      <th>商品分类</th>\n      <th>小店</th>\n      <th>价格</th>\n      <th>销量</th>\n      <th>销售额</th>\n      <th>关联达人</th>\n      <th>关联视频</th>\n      <th>关联直播</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>1</th>\n      <td>康比特益生菌增肌粉复合蛋白粉瘦子增肌增重运动健身学生营养加餐</td>\n      <td>https://www.chanmama.com/promotionDetail/ny43D...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>199.00</td>\n      <td>861</td>\n      <td>171339.00</td>\n      <td>2</td>\n      <td>0</td>\n      <td>2</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS</td>\n      <td>https://www.chanmama.com/promotionDetail/0aUUU...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>366.84</td>\n      <td>446</td>\n      <td>163611.45</td>\n      <td>16</td>\n      <td>1</td>\n      <td>17</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>康比特益生菌增肌粉瘦人增肌增重乳清运动锻炼健身蛋白质粉mass</td>\n      <td>https://www.chanmama.com/promotionDetail/CCqFd...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>79.11</td>\n      <td>1832</td>\n      <td>144932.00</td>\n      <td>14</td>\n      <td>13</td>\n      <td>4</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss</td>\n      <td>https://www.chanmama.com/promotionDetail/1zKky...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>293.45</td>\n      <td>358</td>\n      <td>105056.00</td>\n      <td>3</td>\n      <td>0</td>\n      <td>5</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>【增肌塑形】康比特分离乳清蛋白粉低脂低碳高蛋白健身增肌蛋白粉</td>\n      <td>https://www.chanmama.com/promotionDetail/988c4...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>350.52</td>\n      <td>254</td>\n      <td>89032.00</td>\n      <td>3</td>\n      <td>0</td>\n      <td>4</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>192</th>\n      <td>康比特加速能量胶运动跑步盐丸马拉松越野骑行电解质长跑酸轻片</td>\n      <td>https://www.chanmama.com/promotionDetail/QEOFD...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>利东食品专营店</td>\n      <td>18.00</td>\n      <td>1</td>\n      <td>18.00</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>193</th>\n      <td>康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步</td>\n      <td>https://www.chanmama.com/promotionDetail/Zqvmf...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>食品饮料-酒水/饮料-饮料</td>\n      <td>康比特运动营养水饮旗舰店</td>\n      <td>9.90</td>\n      <td>1</td>\n      <td>9.90</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>194</th>\n      <td>康比特锌镁肌酸便携装6g*10 组合装（口味不可选）运动健身补充</td>\n      <td>https://www.chanmama.com/promotionDetail/lojFm...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>9.90</td>\n      <td>1</td>\n      <td>9.90</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>195</th>\n      <td>康比特运动营养加速电解质盐丸 马拉松运动跑步户外碳水袋装便携</td>\n      <td>https://www.chanmama.com/promotionDetail/gFy1Q...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>食品饮料-酒水/饮料-饮料</td>\n      <td>康比特运动营养水饮旗舰店</td>\n      <td>4.80</td>\n      <td>2</td>\n      <td>9.60</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>196</th>\n      <td>【夏训体验】康比特加速能量胶盐丸润力饮 马拉松长跑 运动补给充能</td>\n      <td>https://www.chanmama.com/promotionDetail/PiYC9...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>利东食品专营店</td>\n      <td>9.00</td>\n      <td>1</td>\n      <td>9.00</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n    </tr>\n  </tbody>\n</table>\n<p>196 rows × 12 columns</p>\n</div>"
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "import sys\n",
    "import pandas as pd\n",
    "\n",
    "folder_path = 'download'\n",
    "files_and_folders = os.listdir(folder_path)\n",
    "item = files_and_folders[0]\n",
    "item_path = os.path.join(folder_path, item)\n",
    "if os.path.isfile(item_path):\n",
    "    name_list = item.split('_')\n",
    "    data_time = name_list[2].split('-')[0]\n",
    "    product_name = name_list[1].split('品牌')[0]\n",
    "    print('brand_name-->', product_name)\n",
    "    print('日期-->', data_time)\n",
    "    data = pd.read_excel(item_path, header=0)\n",
    "    data = data.drop(index=0)\n",
    "data\n",
    "# os.remove(item_path)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "outputs": [
    {
     "data": {
      "text/plain": "                                   商品  \\\n1      康比特益生菌增肌粉复合蛋白粉瘦子增肌增重运动健身学生营养加餐   \n2    康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS   \n3     康比特益生菌增肌粉瘦人增肌增重乳清运动锻炼健身蛋白质粉mass   \n4       康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss   \n5      【增肌塑形】康比特分离乳清蛋白粉低脂低碳高蛋白健身增肌蛋白粉   \n..                                ...   \n192     康比特加速能量胶运动跑步盐丸马拉松越野骑行电解质长跑酸轻片   \n193     康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步   \n194  康比特锌镁肌酸便携装6g*10 组合装（口味不可选）运动健身补充   \n195    康比特运动营养加速电解质盐丸 马拉松运动跑步户外碳水袋装便携   \n196  【夏训体验】康比特加速能量胶盐丸润力饮 马拉松长跑 运动补给充能   \n\n                                               蝉妈妈商品链接  \\\n1    https://www.chanmama.com/promotionDetail/ny43D...   \n2    https://www.chanmama.com/promotionDetail/0aUUU...   \n3    https://www.chanmama.com/promotionDetail/CCqFd...   \n4    https://www.chanmama.com/promotionDetail/1zKky...   \n5    https://www.chanmama.com/promotionDetail/988c4...   \n..                                                 ...   \n192  https://www.chanmama.com/promotionDetail/QEOFD...   \n193  https://www.chanmama.com/promotionDetail/Zqvmf...   \n194  https://www.chanmama.com/promotionDetail/lojFm...   \n195  https://www.chanmama.com/promotionDetail/gFy1Q...   \n196  https://www.chanmama.com/promotionDetail/PiYC9...   \n\n                                                抖音商品链接  \\\n1    https://haohuo.jinritemai.com/ecommerce/trade/...   \n2    https://haohuo.jinritemai.com/ecommerce/trade/...   \n3    https://haohuo.jinritemai.com/ecommerce/trade/...   \n4    https://haohuo.jinritemai.com/ecommerce/trade/...   \n5    https://haohuo.jinritemai.com/ecommerce/trade/...   \n..                                                 ...   \n192  https://haohuo.jinritemai.com/ecommerce/trade/...   \n193  https://haohuo.jinritemai.com/ecommerce/trade/...   \n194  https://haohuo.jinritemai.com/ecommerce/trade/...   \n195  https://haohuo.jinritemai.com/ecommerce/trade/...   \n196  https://haohuo.jinritemai.com/ecommerce/trade/...   \n\n                                                  商品图片               商品分类  \\\n1    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n2    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n3    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n4    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n5    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n..                                                 ...                ...   \n192  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n193  https://cdn-images.chanmama.com/douyin/product...      食品饮料-酒水/饮料-饮料   \n194  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n195  https://cdn-images.chanmama.com/douyin/product...      食品饮料-酒水/饮料-饮料   \n196  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n\n               小店      价格    销量        销售额 关联达人 关联视频 关联直播  \\\n1      康比特运动营养旗舰店  199.00   861  171339.00    2    0    2   \n2        康比特官方旗舰店  366.84   446  163611.45   16    1   17   \n3      康比特运动营养旗舰店   79.11  1832  144932.00   14   13    4   \n4      康比特运动营养旗舰店  293.45   358  105056.00    3    0    5   \n5        康比特官方旗舰店  350.52   254   89032.00    3    0    4   \n..            ...     ...   ...        ...  ...  ...  ...   \n192       利东食品专营店   18.00     1      18.00    0    0    0   \n193  康比特运动营养水饮旗舰店    9.90     1       9.90    0    0    0   \n194      康比特官方旗舰店    9.90     1       9.90    0    0    0   \n195  康比特运动营养水饮旗舰店    4.80     2       9.60    0    0    0   \n196       利东食品专营店    9.00     1       9.00    0    0    0   \n\n                    产品ID     日期 brand_name  \n1    3442982313699464004  8月19日        康比特  \n2    3602894078519473567  8月19日        康比特  \n3    3573214322752675932  8月19日        康比特  \n4    3497550645458818780  8月19日        康比特  \n5    3460831451170395314  8月19日        康比特  \n..                   ...    ...        ...  \n192  3581574103125084125  8月19日        康比特  \n193  3694391513736937864  8月19日        康比特  \n194  3644469786953580041  8月19日        康比特  \n195  3660457388684784786  8月19日        康比特  \n196  3638891163504790644  8月19日        康比特  \n\n[196 rows x 15 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>商品</th>\n      <th>蝉妈妈商品链接</th>\n      <th>抖音商品链接</th>\n      <th>商品图片</th>\n      <th>商品分类</th>\n      <th>小店</th>\n      <th>价格</th>\n      <th>销量</th>\n      <th>销售额</th>\n      <th>关联达人</th>\n      <th>关联视频</th>\n      <th>关联直播</th>\n      <th>产品ID</th>\n      <th>日期</th>\n      <th>brand_name</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>1</th>\n      <td>康比特益生菌增肌粉复合蛋白粉瘦子增肌增重运动健身学生营养加餐</td>\n      <td>https://www.chanmama.com/promotionDetail/ny43D...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>199.00</td>\n      <td>861</td>\n      <td>171339.00</td>\n      <td>2</td>\n      <td>0</td>\n      <td>2</td>\n      <td>3442982313699464004</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS</td>\n      <td>https://www.chanmama.com/promotionDetail/0aUUU...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>366.84</td>\n      <td>446</td>\n      <td>163611.45</td>\n      <td>16</td>\n      <td>1</td>\n      <td>17</td>\n      <td>3602894078519473567</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>康比特益生菌增肌粉瘦人增肌增重乳清运动锻炼健身蛋白质粉mass</td>\n      <td>https://www.chanmama.com/promotionDetail/CCqFd...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>79.11</td>\n      <td>1832</td>\n      <td>144932.00</td>\n      <td>14</td>\n      <td>13</td>\n      <td>4</td>\n      <td>3573214322752675932</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss</td>\n      <td>https://www.chanmama.com/promotionDetail/1zKky...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>293.45</td>\n      <td>358</td>\n      <td>105056.00</td>\n      <td>3</td>\n      <td>0</td>\n      <td>5</td>\n      <td>3497550645458818780</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>【增肌塑形】康比特分离乳清蛋白粉低脂低碳高蛋白健身增肌蛋白粉</td>\n      <td>https://www.chanmama.com/promotionDetail/988c4...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>350.52</td>\n      <td>254</td>\n      <td>89032.00</td>\n      <td>3</td>\n      <td>0</td>\n      <td>4</td>\n      <td>3460831451170395314</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>192</th>\n      <td>康比特加速能量胶运动跑步盐丸马拉松越野骑行电解质长跑酸轻片</td>\n      <td>https://www.chanmama.com/promotionDetail/QEOFD...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>利东食品专营店</td>\n      <td>18.00</td>\n      <td>1</td>\n      <td>18.00</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3581574103125084125</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>193</th>\n      <td>康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步</td>\n      <td>https://www.chanmama.com/promotionDetail/Zqvmf...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>食品饮料-酒水/饮料-饮料</td>\n      <td>康比特运动营养水饮旗舰店</td>\n      <td>9.90</td>\n      <td>1</td>\n      <td>9.90</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3694391513736937864</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>194</th>\n      <td>康比特锌镁肌酸便携装6g*10 组合装（口味不可选）运动健身补充</td>\n      <td>https://www.chanmama.com/promotionDetail/lojFm...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>9.90</td>\n      <td>1</td>\n      <td>9.90</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3644469786953580041</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>195</th>\n      <td>康比特运动营养加速电解质盐丸 马拉松运动跑步户外碳水袋装便携</td>\n      <td>https://www.chanmama.com/promotionDetail/gFy1Q...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>食品饮料-酒水/饮料-饮料</td>\n      <td>康比特运动营养水饮旗舰店</td>\n      <td>4.80</td>\n      <td>2</td>\n      <td>9.60</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3660457388684784786</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>196</th>\n      <td>【夏训体验】康比特加速能量胶盐丸润力饮 马拉松长跑 运动补给充能</td>\n      <td>https://www.chanmama.com/promotionDetail/PiYC9...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>利东食品专营店</td>\n      <td>9.00</td>\n      <td>1</td>\n      <td>9.00</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3638891163504790644</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n  </tbody>\n</table>\n<p>196 rows × 15 columns</p>\n</div>"
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pattern = r'id=(\\d+)'\n",
    "product_ID = data['抖音商品链接'].str.extract(pattern, expand=True)\n",
    "data['产品ID'] = product_ID\n",
    "\n",
    "data"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T09:19:57.376812900Z",
     "start_time": "2024-08-20T09:19:57.368657400Z"
    }
   },
   "id": "f3e5fe9f6772b2cc"
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "outputs": [],
   "source": [
    "from datetime import datetime\n",
    "\n",
    "date_obj = datetime.strptime(data_time, '%Y%m%d')\n",
    "# 获取月份和日期\n",
    "month = date_obj.month\n",
    "day = date_obj.day\n",
    "# 格式化为所需的字符串格式\n",
    "formatted_date = f'{month}月{day}日'\n",
    "data['日期'] = formatted_date"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T10:15:40.470839Z",
     "start_time": "2024-08-20T10:15:40.459935600Z"
    }
   },
   "id": "36e149d30d992118"
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "outputs": [
    {
     "data": {
      "text/plain": "                                   商品  \\\n1      康比特益生菌增肌粉复合蛋白粉瘦子增肌增重运动健身学生营养加餐   \n2    康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS   \n3     康比特益生菌增肌粉瘦人增肌增重乳清运动锻炼健身蛋白质粉mass   \n4       康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss   \n5      【增肌塑形】康比特分离乳清蛋白粉低脂低碳高蛋白健身增肌蛋白粉   \n..                                ...   \n192     康比特加速能量胶运动跑步盐丸马拉松越野骑行电解质长跑酸轻片   \n193     康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步   \n194  康比特锌镁肌酸便携装6g*10 组合装（口味不可选）运动健身补充   \n195    康比特运动营养加速电解质盐丸 马拉松运动跑步户外碳水袋装便携   \n196  【夏训体验】康比特加速能量胶盐丸润力饮 马拉松长跑 运动补给充能   \n\n                                               蝉妈妈商品链接  \\\n1    https://www.chanmama.com/promotionDetail/ny43D...   \n2    https://www.chanmama.com/promotionDetail/0aUUU...   \n3    https://www.chanmama.com/promotionDetail/CCqFd...   \n4    https://www.chanmama.com/promotionDetail/1zKky...   \n5    https://www.chanmama.com/promotionDetail/988c4...   \n..                                                 ...   \n192  https://www.chanmama.com/promotionDetail/QEOFD...   \n193  https://www.chanmama.com/promotionDetail/Zqvmf...   \n194  https://www.chanmama.com/promotionDetail/lojFm...   \n195  https://www.chanmama.com/promotionDetail/gFy1Q...   \n196  https://www.chanmama.com/promotionDetail/PiYC9...   \n\n                                                抖音商品链接  \\\n1    https://haohuo.jinritemai.com/ecommerce/trade/...   \n2    https://haohuo.jinritemai.com/ecommerce/trade/...   \n3    https://haohuo.jinritemai.com/ecommerce/trade/...   \n4    https://haohuo.jinritemai.com/ecommerce/trade/...   \n5    https://haohuo.jinritemai.com/ecommerce/trade/...   \n..                                                 ...   \n192  https://haohuo.jinritemai.com/ecommerce/trade/...   \n193  https://haohuo.jinritemai.com/ecommerce/trade/...   \n194  https://haohuo.jinritemai.com/ecommerce/trade/...   \n195  https://haohuo.jinritemai.com/ecommerce/trade/...   \n196  https://haohuo.jinritemai.com/ecommerce/trade/...   \n\n                                                  商品图片               商品分类  \\\n1    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n2    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n3    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n4    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n5    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n..                                                 ...                ...   \n192  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n193  https://cdn-images.chanmama.com/douyin/product...      食品饮料-酒水/饮料-饮料   \n194  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n195  https://cdn-images.chanmama.com/douyin/product...      食品饮料-酒水/饮料-饮料   \n196  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n\n               小店      价格    销量        销售额 关联达人 关联视频 关联直播  \\\n1      康比特运动营养旗舰店  199.00   861  171339.00    2    0    2   \n2        康比特官方旗舰店  366.84   446  163611.45   16    1   17   \n3      康比特运动营养旗舰店   79.11  1832  144932.00   14   13    4   \n4      康比特运动营养旗舰店  293.45   358  105056.00    3    0    5   \n5        康比特官方旗舰店  350.52   254   89032.00    3    0    4   \n..            ...     ...   ...        ...  ...  ...  ...   \n192       利东食品专营店   18.00     1      18.00    0    0    0   \n193  康比特运动营养水饮旗舰店    9.90     1       9.90    0    0    0   \n194      康比特官方旗舰店    9.90     1       9.90    0    0    0   \n195  康比特运动营养水饮旗舰店    4.80     2       9.60    0    0    0   \n196       利东食品专营店    9.00     1       9.00    0    0    0   \n\n                    产品ID     日期 brand_name  \n1    3442982313699464004  8月19日        康比特  \n2    3602894078519473567  8月19日        康比特  \n3    3573214322752675932  8月19日        康比特  \n4    3497550645458818780  8月19日        康比特  \n5    3460831451170395314  8月19日        康比特  \n..                   ...    ...        ...  \n192  3581574103125084125  8月19日        康比特  \n193  3694391513736937864  8月19日        康比特  \n194  3644469786953580041  8月19日        康比特  \n195  3660457388684784786  8月19日        康比特  \n196  3638891163504790644  8月19日        康比特  \n\n[196 rows x 15 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>商品</th>\n      <th>蝉妈妈商品链接</th>\n      <th>抖音商品链接</th>\n      <th>商品图片</th>\n      <th>商品分类</th>\n      <th>小店</th>\n      <th>价格</th>\n      <th>销量</th>\n      <th>销售额</th>\n      <th>关联达人</th>\n      <th>关联视频</th>\n      <th>关联直播</th>\n      <th>产品ID</th>\n      <th>日期</th>\n      <th>brand_name</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>1</th>\n      <td>康比特益生菌增肌粉复合蛋白粉瘦子增肌增重运动健身学生营养加餐</td>\n      <td>https://www.chanmama.com/promotionDetail/ny43D...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>199.00</td>\n      <td>861</td>\n      <td>171339.00</td>\n      <td>2</td>\n      <td>0</td>\n      <td>2</td>\n      <td>3442982313699464004</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS</td>\n      <td>https://www.chanmama.com/promotionDetail/0aUUU...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>366.84</td>\n      <td>446</td>\n      <td>163611.45</td>\n      <td>16</td>\n      <td>1</td>\n      <td>17</td>\n      <td>3602894078519473567</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>康比特益生菌增肌粉瘦人增肌增重乳清运动锻炼健身蛋白质粉mass</td>\n      <td>https://www.chanmama.com/promotionDetail/CCqFd...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>79.11</td>\n      <td>1832</td>\n      <td>144932.00</td>\n      <td>14</td>\n      <td>13</td>\n      <td>4</td>\n      <td>3573214322752675932</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss</td>\n      <td>https://www.chanmama.com/promotionDetail/1zKky...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>293.45</td>\n      <td>358</td>\n      <td>105056.00</td>\n      <td>3</td>\n      <td>0</td>\n      <td>5</td>\n      <td>3497550645458818780</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>【增肌塑形】康比特分离乳清蛋白粉低脂低碳高蛋白健身增肌蛋白粉</td>\n      <td>https://www.chanmama.com/promotionDetail/988c4...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>350.52</td>\n      <td>254</td>\n      <td>89032.00</td>\n      <td>3</td>\n      <td>0</td>\n      <td>4</td>\n      <td>3460831451170395314</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>192</th>\n      <td>康比特加速能量胶运动跑步盐丸马拉松越野骑行电解质长跑酸轻片</td>\n      <td>https://www.chanmama.com/promotionDetail/QEOFD...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>利东食品专营店</td>\n      <td>18.00</td>\n      <td>1</td>\n      <td>18.00</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3581574103125084125</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>193</th>\n      <td>康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步</td>\n      <td>https://www.chanmama.com/promotionDetail/Zqvmf...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>食品饮料-酒水/饮料-饮料</td>\n      <td>康比特运动营养水饮旗舰店</td>\n      <td>9.90</td>\n      <td>1</td>\n      <td>9.90</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3694391513736937864</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>194</th>\n      <td>康比特锌镁肌酸便携装6g*10 组合装（口味不可选）运动健身补充</td>\n      <td>https://www.chanmama.com/promotionDetail/lojFm...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>9.90</td>\n      <td>1</td>\n      <td>9.90</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3644469786953580041</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>195</th>\n      <td>康比特运动营养加速电解质盐丸 马拉松运动跑步户外碳水袋装便携</td>\n      <td>https://www.chanmama.com/promotionDetail/gFy1Q...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>食品饮料-酒水/饮料-饮料</td>\n      <td>康比特运动营养水饮旗舰店</td>\n      <td>4.80</td>\n      <td>2</td>\n      <td>9.60</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3660457388684784786</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>196</th>\n      <td>【夏训体验】康比特加速能量胶盐丸润力饮 马拉松长跑 运动补给充能</td>\n      <td>https://www.chanmama.com/promotionDetail/PiYC9...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>利东食品专营店</td>\n      <td>9.00</td>\n      <td>1</td>\n      <td>9.00</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3638891163504790644</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n  </tbody>\n</table>\n<p>196 rows × 15 columns</p>\n</div>"
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['brand_name'] = product_name\n",
    "data"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T10:15:45.633135100Z",
     "start_time": "2024-08-20T10:15:45.609343700Z"
    }
   },
   "id": "95f7c9d997dd80ec"
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "outputs": [
    {
     "data": {
      "text/plain": "Index(['商品', '蝉妈妈商品链接', '抖音商品链接', '商品图片', '商品分类', '小店', '价格', '销量', '销售额',\n       '关联达人', '关联视频', '关联直播', '产品ID', '日期', 'brand_name'],\n      dtype='object')"
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T10:16:08.131205500Z",
     "start_time": "2024-08-20T10:16:08.113323300Z"
    }
   },
   "id": "59cb8ac219e1d505"
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false
   },
   "id": "a416d51c6da486d3"
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false
   },
   "id": "d702a83d22e16186"
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "outputs": [
    {
     "data": {
      "text/plain": "                                   商品  \\\n1      康比特益生菌增肌粉复合蛋白粉瘦子增肌增重运动健身学生营养加餐   \n2    康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS   \n3     康比特益生菌增肌粉瘦人增肌增重乳清运动锻炼健身蛋白质粉mass   \n4       康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss   \n5      【增肌塑形】康比特分离乳清蛋白粉低脂低碳高蛋白健身增肌蛋白粉   \n..                                ...   \n192     康比特加速能量胶运动跑步盐丸马拉松越野骑行电解质长跑酸轻片   \n193     康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步   \n194  康比特锌镁肌酸便携装6g*10 组合装（口味不可选）运动健身补充   \n195    康比特运动营养加速电解质盐丸 马拉松运动跑步户外碳水袋装便携   \n196  【夏训体验】康比特加速能量胶盐丸润力饮 马拉松长跑 运动补给充能   \n\n                                               蝉妈妈商品链接  \\\n1    https://www.chanmama.com/promotionDetail/ny43D...   \n2    https://www.chanmama.com/promotionDetail/0aUUU...   \n3    https://www.chanmama.com/promotionDetail/CCqFd...   \n4    https://www.chanmama.com/promotionDetail/1zKky...   \n5    https://www.chanmama.com/promotionDetail/988c4...   \n..                                                 ...   \n192  https://www.chanmama.com/promotionDetail/QEOFD...   \n193  https://www.chanmama.com/promotionDetail/Zqvmf...   \n194  https://www.chanmama.com/promotionDetail/lojFm...   \n195  https://www.chanmama.com/promotionDetail/gFy1Q...   \n196  https://www.chanmama.com/promotionDetail/PiYC9...   \n\n                                                抖音商品链接  \\\n1    https://haohuo.jinritemai.com/ecommerce/trade/...   \n2    https://haohuo.jinritemai.com/ecommerce/trade/...   \n3    https://haohuo.jinritemai.com/ecommerce/trade/...   \n4    https://haohuo.jinritemai.com/ecommerce/trade/...   \n5    https://haohuo.jinritemai.com/ecommerce/trade/...   \n..                                                 ...   \n192  https://haohuo.jinritemai.com/ecommerce/trade/...   \n193  https://haohuo.jinritemai.com/ecommerce/trade/...   \n194  https://haohuo.jinritemai.com/ecommerce/trade/...   \n195  https://haohuo.jinritemai.com/ecommerce/trade/...   \n196  https://haohuo.jinritemai.com/ecommerce/trade/...   \n\n                                                  商品图片               商品分类  \\\n1    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n2    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n3    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n4    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n5    https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n..                                                 ...                ...   \n192  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n193  https://cdn-images.chanmama.com/douyin/product...      食品饮料-酒水/饮料-饮料   \n194  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n195  https://cdn-images.chanmama.com/douyin/product...      食品饮料-酒水/饮料-饮料   \n196  https://cdn-images.chanmama.com/douyin/product...  医药保健-保健品-普通膳食营养食品   \n\n               小店      价格    销量        销售额 关联达人 关联视频 关联直播  \\\n1      康比特运动营养旗舰店  199.00   861  171339.00    2    0    2   \n2        康比特官方旗舰店  366.84   446  163611.45   16    1   17   \n3      康比特运动营养旗舰店   79.11  1832  144932.00   14   13    4   \n4      康比特运动营养旗舰店  293.45   358  105056.00    3    0    5   \n5        康比特官方旗舰店  350.52   254   89032.00    3    0    4   \n..            ...     ...   ...        ...  ...  ...  ...   \n192       利东食品专营店   18.00     1      18.00    0    0    0   \n193  康比特运动营养水饮旗舰店    9.90     1       9.90    0    0    0   \n194      康比特官方旗舰店    9.90     1       9.90    0    0    0   \n195  康比特运动营养水饮旗舰店    4.80     2       9.60    0    0    0   \n196       利东食品专营店    9.00     1       9.00    0    0    0   \n\n                    产品ID     日期 brand_name  \n1    3442982313699464004  8月19日        康比特  \n2    3602894078519473567  8月19日        康比特  \n3    3573214322752675932  8月19日        康比特  \n4    3497550645458818780  8月19日        康比特  \n5    3460831451170395314  8月19日        康比特  \n..                   ...    ...        ...  \n192  3581574103125084125  8月19日        康比特  \n193  3694391513736937864  8月19日        康比特  \n194  3644469786953580041  8月19日        康比特  \n195  3660457388684784786  8月19日        康比特  \n196  3638891163504790644  8月19日        康比特  \n\n[196 rows x 15 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>商品</th>\n      <th>蝉妈妈商品链接</th>\n      <th>抖音商品链接</th>\n      <th>商品图片</th>\n      <th>商品分类</th>\n      <th>小店</th>\n      <th>价格</th>\n      <th>销量</th>\n      <th>销售额</th>\n      <th>关联达人</th>\n      <th>关联视频</th>\n      <th>关联直播</th>\n      <th>产品ID</th>\n      <th>日期</th>\n      <th>brand_name</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>1</th>\n      <td>康比特益生菌增肌粉复合蛋白粉瘦子增肌增重运动健身学生营养加餐</td>\n      <td>https://www.chanmama.com/promotionDetail/ny43D...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>199.00</td>\n      <td>861</td>\n      <td>171339.00</td>\n      <td>2</td>\n      <td>0</td>\n      <td>2</td>\n      <td>3442982313699464004</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白质高蛋白SSS</td>\n      <td>https://www.chanmama.com/promotionDetail/0aUUU...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>366.84</td>\n      <td>446</td>\n      <td>163611.45</td>\n      <td>16</td>\n      <td>1</td>\n      <td>17</td>\n      <td>3602894078519473567</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>康比特益生菌增肌粉瘦人增肌增重乳清运动锻炼健身蛋白质粉mass</td>\n      <td>https://www.chanmama.com/promotionDetail/CCqFd...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>79.11</td>\n      <td>1832</td>\n      <td>144932.00</td>\n      <td>14</td>\n      <td>13</td>\n      <td>4</td>\n      <td>3573214322752675932</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>康比特酸奶乳清蛋白粉益生菌4磅运动营养健身增肌蛋白粉sss</td>\n      <td>https://www.chanmama.com/promotionDetail/1zKky...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特运动营养旗舰店</td>\n      <td>293.45</td>\n      <td>358</td>\n      <td>105056.00</td>\n      <td>3</td>\n      <td>0</td>\n      <td>5</td>\n      <td>3497550645458818780</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>【增肌塑形】康比特分离乳清蛋白粉低脂低碳高蛋白健身增肌蛋白粉</td>\n      <td>https://www.chanmama.com/promotionDetail/988c4...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>350.52</td>\n      <td>254</td>\n      <td>89032.00</td>\n      <td>3</td>\n      <td>0</td>\n      <td>4</td>\n      <td>3460831451170395314</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>192</th>\n      <td>康比特加速能量胶运动跑步盐丸马拉松越野骑行电解质长跑酸轻片</td>\n      <td>https://www.chanmama.com/promotionDetail/QEOFD...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>利东食品专营店</td>\n      <td>18.00</td>\n      <td>1</td>\n      <td>18.00</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3581574103125084125</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>193</th>\n      <td>康比特运动营养加速电解质盐丸马拉松运动跑步户外袋装便携跑步</td>\n      <td>https://www.chanmama.com/promotionDetail/Zqvmf...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>食品饮料-酒水/饮料-饮料</td>\n      <td>康比特运动营养水饮旗舰店</td>\n      <td>9.90</td>\n      <td>1</td>\n      <td>9.90</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3694391513736937864</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>194</th>\n      <td>康比特锌镁肌酸便携装6g*10 组合装（口味不可选）运动健身补充</td>\n      <td>https://www.chanmama.com/promotionDetail/lojFm...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>康比特官方旗舰店</td>\n      <td>9.90</td>\n      <td>1</td>\n      <td>9.90</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3644469786953580041</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>195</th>\n      <td>康比特运动营养加速电解质盐丸 马拉松运动跑步户外碳水袋装便携</td>\n      <td>https://www.chanmama.com/promotionDetail/gFy1Q...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>食品饮料-酒水/饮料-饮料</td>\n      <td>康比特运动营养水饮旗舰店</td>\n      <td>4.80</td>\n      <td>2</td>\n      <td>9.60</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3660457388684784786</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n    <tr>\n      <th>196</th>\n      <td>【夏训体验】康比特加速能量胶盐丸润力饮 马拉松长跑 运动补给充能</td>\n      <td>https://www.chanmama.com/promotionDetail/PiYC9...</td>\n      <td>https://haohuo.jinritemai.com/ecommerce/trade/...</td>\n      <td>https://cdn-images.chanmama.com/douyin/product...</td>\n      <td>医药保健-保健品-普通膳食营养食品</td>\n      <td>利东食品专营店</td>\n      <td>9.00</td>\n      <td>1</td>\n      <td>9.00</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>3638891163504790644</td>\n      <td>8月19日</td>\n      <td>康比特</td>\n    </tr>\n  </tbody>\n</table>\n<p>196 rows × 15 columns</p>\n</div>"
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T10:15:15.784478800Z",
     "start_time": "2024-08-20T10:15:15.760140900Z"
    }
   },
   "id": "ed907f828d6ba950"
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3442982313699464004\n"
     ]
    }
   ],
   "source": [
    "for index, row in data.iterrows():\n",
    "    print(row['产品ID'])\n",
    "    break"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T10:18:54.185913300Z",
     "start_time": "2024-08-20T10:18:54.168723Z"
    }
   },
   "id": "bfcebf0f3e6f4029"
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T09:41:38.996639900Z",
     "start_time": "2024-08-20T09:41:38.988819Z"
    }
   },
   "id": "1ab67a3db9914c5b"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.430306300Z",
     "start_time": "2024-08-20T07:06:40.944730200Z"
    }
   },
   "id": "f4daeafdc157172b"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.430306300Z",
     "start_time": "2024-08-20T07:06:40.962900200Z"
    }
   },
   "id": "9bc14fd2ca9a948c"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.430306300Z",
     "start_time": "2024-08-20T07:06:40.977027900Z"
    }
   },
   "id": "fcd570ccb4fe58f2"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.430306300Z",
     "start_time": "2024-08-20T07:06:40.991769400Z"
    }
   },
   "id": "6271c39907721243"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.430306300Z",
     "start_time": "2024-08-20T07:06:41.007511300Z"
    }
   },
   "id": "f8874c2da73311bd"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.430306300Z",
     "start_time": "2024-08-20T07:06:41.022185100Z"
    }
   },
   "id": "6b651dcf5268205e"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.430306300Z",
     "start_time": "2024-08-20T07:06:41.037734200Z"
    }
   },
   "id": "4a4a9fdbaa48c70b"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.431311700Z",
     "start_time": "2024-08-20T07:06:41.055426700Z"
    }
   },
   "id": "dab701569c3b7542"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.431311700Z",
     "start_time": "2024-08-20T07:06:41.068948600Z"
    }
   },
   "id": "f4cfee49a81ed00a"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.431311700Z",
     "start_time": "2024-08-20T07:06:41.085905600Z"
    }
   },
   "id": "512902b15da3eb41"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [
    "import cx_Oracle\n",
    "\n",
    "dsn = cx_Oracle.makedsn('8.141.85.230', 1521, \"orcl\")\n",
    "connection = cx_Oracle.connect('dyyy', 'cpt123', dsn)\n",
    "cursor = connection.cursor()\n",
    "insert_sql = f\"\"\"\n",
    "    select 品牌, 品类\n",
    "from 产品ID匹配品牌品类表 where 产品ID={product_ID}\n",
    "\"\"\"\n",
    "cursor.execute(insert_sql)\n",
    "brand, category, = cursor.fetchone()\n",
    "data['品牌'] = brand\n",
    "data['品类'] = category\n",
    "\n"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.431311700Z",
     "start_time": "2024-08-20T07:06:41.101247800Z"
    }
   },
   "id": "3a87b325f460edca"
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "outputs": [
    {
     "data": {
      "text/plain": "Index(['商品', '蝉妈妈商品链接', '抖音商品链接', '商品图片', '商品分类', '小店', '价格', '销量', '销售额',\n       '关联达人', '关联视频', '关联直播', '产品ID', '日期', 'brand_name'],\n      dtype='object')"
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T12:55:40.414385600Z",
     "start_time": "2024-08-20T12:55:40.406952800Z"
    }
   },
   "id": "dc7e429a6c8739b9"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.432311500Z",
     "start_time": "2024-08-20T07:06:41.132065200Z"
    }
   },
   "id": "bc37736b34605c10"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.432311500Z",
     "start_time": "2024-08-20T07:06:41.147631500Z"
    }
   },
   "id": "c5f86d03e714cd6a"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.432311500Z",
     "start_time": "2024-08-20T07:06:41.162801700Z"
    }
   },
   "id": "8d10d2b9a4728545"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.432311500Z",
     "start_time": "2024-08-20T07:06:41.181891900Z"
    }
   },
   "id": "b85c3c75d13aeb7e"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.432311500Z",
     "start_time": "2024-08-20T07:06:41.194944400Z"
    }
   },
   "id": "755cee3aace21cda"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.432311500Z",
     "start_time": "2024-08-20T07:06:41.211287Z"
    }
   },
   "id": "493ea106c87c196c"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.433312100Z",
     "start_time": "2024-08-20T07:06:41.225394600Z"
    }
   },
   "id": "fe90f67edeaf6ae8"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.433312100Z",
     "start_time": "2024-08-20T07:06:41.240702500Z"
    }
   },
   "id": "7bf31f0ac414eabc"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.433312100Z",
     "start_time": "2024-08-20T07:06:41.255772100Z"
    }
   },
   "id": "433880a799de9917"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.434311800Z",
     "start_time": "2024-08-20T07:06:41.273068900Z"
    }
   },
   "id": "c45b22372cda385f"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.434311800Z",
     "start_time": "2024-08-20T07:06:41.288610400Z"
    }
   },
   "id": "57061dd88c34cff9"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.435315100Z",
     "start_time": "2024-08-20T07:06:41.303580200Z"
    }
   },
   "id": "7109310dc563c45a"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.435315100Z",
     "start_time": "2024-08-20T07:06:41.370609300Z"
    }
   },
   "id": "819bdad2573d2ff9"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.435315100Z",
     "start_time": "2024-08-20T07:06:41.370609300Z"
    }
   },
   "id": "d1dc7959f2fee45b"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.435315100Z",
     "start_time": "2024-08-20T07:06:41.372120100Z"
    }
   },
   "id": "dd1c9350ff6c4e5d"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.435315100Z",
     "start_time": "2024-08-20T07:06:41.372120100Z"
    }
   },
   "id": "e13ddfa87b7cb788"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.435315100Z",
     "start_time": "2024-08-20T07:06:41.382643900Z"
    }
   },
   "id": "52e3955ba326cd15"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.435315100Z",
     "start_time": "2024-08-20T07:06:41.397152700Z"
    }
   },
   "id": "39f6fc6d932e2e2e"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.453124500Z",
     "start_time": "2024-08-20T07:06:41.413755700Z"
    }
   },
   "id": "8e9092e452c68d19"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.562957900Z",
     "start_time": "2024-08-20T07:06:41.429300800Z"
    }
   },
   "id": "aa28af703ff5752c"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.570466200Z",
     "start_time": "2024-08-20T07:06:41.445823600Z"
    }
   },
   "id": "44c6c80f13c128ad"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.571970600Z",
     "start_time": "2024-08-20T07:06:41.461733Z"
    }
   },
   "id": "de216abaa08fbea2"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.571970600Z",
     "start_time": "2024-08-20T07:06:41.477310100Z"
    }
   },
   "id": "7ec2154eac1c9da6"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.571970600Z",
     "start_time": "2024-08-20T07:06:41.490998300Z"
    }
   },
   "id": "a018e405f970fcee"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.626827Z",
     "start_time": "2024-08-20T07:06:41.507145900Z"
    }
   },
   "id": "4a9c495ebfeb8439"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.658858300Z",
     "start_time": "2024-08-20T07:06:41.521839600Z"
    }
   },
   "id": "144183aaf2af05b4"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.671938Z",
     "start_time": "2024-08-20T07:06:41.537453600Z"
    }
   },
   "id": "f7e6ac7d975bba78"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.672891400Z",
     "start_time": "2024-08-20T07:06:41.552174500Z"
    }
   },
   "id": "e965884bda12e4a8"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.736884900Z",
     "start_time": "2024-08-20T07:06:41.567957200Z"
    }
   },
   "id": "e72832735f310c02"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.796064800Z",
     "start_time": "2024-08-20T07:06:41.585048300Z"
    }
   },
   "id": "4d1bc99eeea43e26"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.797065100Z",
     "start_time": "2024-08-20T07:06:41.600112800Z"
    }
   },
   "id": "fbe010419fe9d0d0"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.797065100Z",
     "start_time": "2024-08-20T07:06:41.616651600Z"
    }
   },
   "id": "fb7f6892df049e9c"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.808825800Z",
     "start_time": "2024-08-20T07:06:41.631033700Z"
    }
   },
   "id": "3f67f2b57b195271"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.835535300Z",
     "start_time": "2024-08-20T07:06:41.646549600Z"
    }
   },
   "id": "270e18535e1eb462"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.837525400Z",
     "start_time": "2024-08-20T07:06:41.661775400Z"
    }
   },
   "id": "74bd1b961746d0ee"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.837525400Z",
     "start_time": "2024-08-20T07:06:41.676893100Z"
    }
   },
   "id": "505d958f8f98ced3"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.837525400Z",
     "start_time": "2024-08-20T07:06:41.692554500Z"
    }
   },
   "id": "b96fadd4a9a18c62"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.837525400Z",
     "start_time": "2024-08-20T07:06:41.708577200Z"
    }
   },
   "id": "55a22d5ddddcfac3"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.838508900Z",
     "start_time": "2024-08-20T07:06:41.723368600Z"
    }
   },
   "id": "6854d8a8ec34a0cf"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.842607600Z",
     "start_time": "2024-08-20T07:06:41.740441100Z"
    }
   },
   "id": "33a6da5bc5c2490a"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.870353Z",
     "start_time": "2024-08-20T07:06:41.756465400Z"
    }
   },
   "id": "e100d31530057c52"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.871927600Z",
     "start_time": "2024-08-20T07:06:41.772029300Z"
    }
   },
   "id": "3018d581e8e9d5d9"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.874889900Z",
     "start_time": "2024-08-20T07:06:41.788552900Z"
    }
   },
   "id": "28212f1065f2f973"
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false,
    "ExecuteTime": {
     "end_time": "2024-08-20T07:06:41.875890300Z",
     "start_time": "2024-08-20T07:06:41.802577200Z"
    }
   },
   "id": "bd73dde976cae289"
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
